station

Dataset statistics

Number of variables	16
Number of observations	108035
Missing cells	422673
Missing cells (%)	24.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	13.2 MiB
Average record size in memory	128.0 B

Variable types

Categorical	3
Numeric	13

Alerts

`StationId` has a high cardinality: 110 distinct values	High cardinality
`Date` has a high cardinality: 2009 distinct values	High cardinality
`PM2.5` is highly correlated with `PM10` and 4 other fields	High correlation
`PM10` is highly correlated with `PM2.5` and 6 other fields	High correlation
`NO` is highly correlated with `PM2.5` and 4 other fields	High correlation
`NO2` is highly correlated with `PM2.5` and 4 other fields	High correlation
`NOx` is highly correlated with `PM10` and 3 other fields	High correlation
`NH3` is highly correlated with `PM2.5` and 2 other fields	High correlation
`CO` is highly correlated with `PM10` and 1 other fields	High correlation
`Benzene` is highly correlated with `Toluene` and 1 other fields	High correlation
`Toluene` is highly correlated with `Benzene` and 1 other fields	High correlation
`Xylene` is highly correlated with `Benzene` and 1 other fields	High correlation
`AQI` is highly correlated with `PM2.5` and 6 other fields	High correlation
`PM2.5` is highly correlated with `PM10` and 1 other fields	High correlation
`PM10` is highly correlated with `PM2.5` and 3 other fields	High correlation
`NO` is highly correlated with `PM10` and 2 other fields	High correlation
`NO2` is highly correlated with `NO` and 1 other fields	High correlation
`NOx` is highly correlated with `PM10` and 2 other fields	High correlation
`Toluene` is highly correlated with `Xylene`	High correlation
`Xylene` is highly correlated with `Toluene`	High correlation
`AQI` is highly correlated with `PM2.5` and 1 other fields	High correlation
`PM2.5` is highly correlated with `PM10` and 1 other fields	High correlation
`PM10` is highly correlated with `PM2.5` and 1 other fields	High correlation
`NO` is highly correlated with `NOx`	High correlation
`NO2` is highly correlated with `NOx`	High correlation
`NOx` is highly correlated with `NO` and 1 other fields	High correlation
`Benzene` is highly correlated with `Toluene` and 1 other fields	High correlation
`Toluene` is highly correlated with `Benzene` and 1 other fields	High correlation
`Xylene` is highly correlated with `Benzene` and 1 other fields	High correlation
`AQI` is highly correlated with `PM2.5` and 1 other fields	High correlation
`PM2.5` is highly correlated with `PM10` and 2 other fields	High correlation
`PM10` is highly correlated with `PM2.5` and 3 other fields	High correlation
`NO` is highly correlated with `NO2` and 1 other fields	High correlation
`NO2` is highly correlated with `NO` and 1 other fields	High correlation
`NOx` is highly correlated with `PM10` and 2 other fields	High correlation
`CO` is highly correlated with `AQI`	High correlation
`Benzene` is highly correlated with `Toluene`	High correlation
`Toluene` is highly correlated with `Benzene`	High correlation
`AQI` is highly correlated with `PM2.5` and 3 other fields	High correlation
`AQI_Bucket` is highly correlated with `PM2.5` and 2 other fields	High correlation
`PM2.5` has 21625 (20.0%) missing values	Missing
`PM10` has 42706 (39.5%) missing values	Missing
`NO` has 17106 (15.8%) missing values	Missing
`NO2` has 16547 (15.3%) missing values	Missing
`NOx` has 15500 (14.3%) missing values	Missing
`NH3` has 48105 (44.5%) missing values	Missing
`CO` has 12998 (12.0%) missing values	Missing
`SO2` has 25204 (23.3%) missing values	Missing
`O3` has 25568 (23.7%) missing values	Missing
`Benzene` has 31455 (29.1%) missing values	Missing
`Toluene` has 38702 (35.8%) missing values	Missing
`Xylene` has 85137 (78.8%) missing values	Missing
`AQI` has 21010 (19.4%) missing values	Missing
`AQI_Bucket` has 21010 (19.4%) missing values	Missing
`Benzene` is highly skewed (γ1 = 21.61702016)	Skewed
`NOx` has 4776 (4.4%) zeros	Zeros
`CO` has 7280 (6.7%) zeros	Zeros
`Benzene` has 12602 (11.7%) zeros	Zeros
`Toluene` has 10455 (9.7%) zeros	Zeros
`Xylene` has 6083 (5.6%) zeros	Zeros

Reproduction

Analysis started	2021-12-26 17:02:29.205525
Analysis finished	2021-12-26 17:02:54.278279
Duration	25.07 seconds
Software version	pandas-profiling v3.1.1
Download configuration	config.json

StationId
Categorical

HIGH CARDINALITY

Distinct	110
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	844.1 KiB

UP012	2009
TN001	2009
DL021	2009
DL008	2009
KA009	2009
Other values (105)	97990

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	540175
Distinct characters	29
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AP001
2nd row	AP001
3rd row	AP001
4th row	AP001
5th row	AP001

Common Values

Value	Count	Frequency (%)
UP012	2009	1.9%
TN001	2009	1.9%
DL021	2009	1.9%
DL008	2009	1.9%
KA009	2009	1.9%
TN003	2009	1.9%
KA003	2009	1.9%
DL007	2009	1.9%
DL033	2009	1.9%
DL013	2009	1.9%
Other values (100)	87945	81.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
up012	2009	1.9%
dl033	2009	1.9%
mh005	2009	1.9%
up014	2009	1.9%
gj001	2009	1.9%
tn004	2009	1.9%
dl013	2009	1.9%
tn001	2009	1.9%
dl007	2009	1.9%
ka003	2009	1.9%
Other values (100)	87945	81.4%

Most occurring characters

Value	Count	Frequency (%)
0	171293	31.7%
1	48475	9.0%
L	47246	8.7%
D	47223	8.7%
3	23227	4.3%
2	21884	4.1%
T	15544	2.9%
A	14911	2.8%
4	14632	2.7%
K	13572	2.5%
Other values (19)	122168	22.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	324105	60.0%
Uppercase Letter	216070	40.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
L	47246	21.9%
D	47223	21.9%
T	15544	7.2%
A	14911	6.9%
K	13572	6.3%
G	10761	5.0%
P	10022	4.6%
H	9808	4.5%
R	8598	4.0%
B	7064	3.3%
Other values (9)	31321	14.5%

Decimal Number

Value	Count	Frequency (%)
0	171293	52.9%
1	48475	15.0%
3	23227	7.2%
2	21884	6.8%
4	14632	4.5%
5	13083	4.0%
8	8417	2.6%
6	8350	2.6%
7	8231	2.5%
9	6513	2.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	324105	60.0%
Latin	216070	40.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
L	47246	21.9%
D	47223	21.9%
T	15544	7.2%
A	14911	6.9%
K	13572	6.3%
G	10761	5.0%
P	10022	4.6%
H	9808	4.5%
R	8598	4.0%
B	7064	3.3%
Other values (9)	31321	14.5%

Common

Value	Count	Frequency (%)
0	171293	52.9%
1	48475	15.0%
3	23227	7.2%
2	21884	6.8%
4	14632	4.5%
5	13083	4.0%
8	8417	2.6%
6	8350	2.6%
7	8231	2.5%
9	6513	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	540175	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	171293	31.7%
1	48475	9.0%
L	47246	8.7%
D	47223	8.7%
3	23227	4.3%
2	21884	4.1%
T	15544	2.9%
A	14911	2.8%
4	14632	2.7%
K	13572	2.5%
Other values (19)	122168	22.6%

Date
Categorical

HIGH CARDINALITY

Distinct	2009
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Memory size	844.1 KiB

2020-03-19	108
2020-06-17	108
2020-04-10	108
2020-06-24	108
2020-04-12	108
Other values (2004)	107495

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	1080350
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017-11-24
2nd row	2017-11-25
3rd row	2017-11-26
4th row	2017-11-27
5th row	2017-11-28

Common Values

Value	Count	Frequency (%)
2020-03-19	108	0.1%
2020-06-17	108	0.1%
2020-04-10	108	0.1%
2020-06-24	108	0.1%
2020-04-12	108	0.1%
2020-04-27	108	0.1%
2020-06-28	108	0.1%
2020-06-16	108	0.1%
2020-04-05	108	0.1%
2020-05-27	108	0.1%
Other values (1999)	106955	99.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2020-03-19	108	0.1%
2020-05-03	108	0.1%
2020-03-13	108	0.1%
2020-06-08	108	0.1%
2020-06-10	108	0.1%
2020-04-23	108	0.1%
2020-06-06	108	0.1%
2020-04-16	108	0.1%
2020-05-20	108	0.1%
2020-05-04	108	0.1%
Other values (1999)	106955	99.0%

Most occurring characters

Value	Count	Frequency (%)
0	260693	24.1%
-	216070	20.0%
2	191188	17.7%
1	179627	16.6%
9	50830	4.7%
8	44185	4.1%
7	32023	3.0%
6	30810	2.9%
5	28358	2.6%
3	25989	2.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	864280	80.0%
Dash Punctuation	216070	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	260693	30.2%
2	191188	22.1%
1	179627	20.8%
9	50830	5.9%
8	44185	5.1%
7	32023	3.7%
6	30810	3.6%
5	28358	3.3%
3	25989	3.0%
4	20577	2.4%

Dash Punctuation

Value	Count	Frequency (%)
-	216070	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1080350	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	260693	24.1%
-	216070	20.0%
2	191188	17.7%
1	179627	16.6%
9	50830	4.7%
8	44185	4.1%
7	32023	3.0%
6	30810	2.9%
5	28358	2.6%
3	25989	2.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1080350	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	260693	24.1%
-	216070	20.0%
2	191188	17.7%
1	179627	16.6%
9	50830	4.7%
8	44185	4.1%
7	32023	3.0%
6	30810	2.9%
5	28358	2.6%
3	25989	2.4%

PM2.5
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	22395
Distinct (%)	25.9%
Missing	21625
Missing (%)	20.0%
Infinite	0
Infinite (%)	0.0%
Mean	80.27257135

Minimum	0.02
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0.02
5-th percentile	13.02
Q1	31.88
median	55.95
Q3	99.92
95-th percentile	236.5655
Maximum	1000
Range	999.98
Interquartile range (IQR)	68.04

Descriptive statistics

Standard deviation	76.52640254
Coefficient of variation (CV)	0.9533318948
Kurtosis	10.62438324
Mean	80.27257135
Median Absolute Deviation (MAD)	29.07
Skewness	2.563923541
Sum	6936352.89
Variance	5856.290285
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11	27	< 0.1%
31.08	23	< 0.1%
28.8	22	< 0.1%
24.83	22	< 0.1%
21.38	21	< 0.1%
42.5	21	< 0.1%
34.1	21	< 0.1%
29.75	21	< 0.1%
15	20	< 0.1%
21	20	< 0.1%
Other values (22385)	86192	79.8%
(Missing)	21625	20.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.02	2	< 0.1%
0.04	1	< 0.1%
0.15	1	< 0.1%
0.16	1	< 0.1%
0.19	1	< 0.1%
0.2	1	< 0.1%
0.24	1	< 0.1%
0.25	1	< 0.1%
0.28	1	< 0.1%
0.32	1	< 0.1%

Value	Count	Frequency (%)
1000	1	< 0.1%
999.99	1	< 0.1%
995	1	< 0.1%
992.67	1	< 0.1%
949.99	1	< 0.1%
917.77	1	< 0.1%
916.67	1	< 0.1%
914.94	1	< 0.1%
914.64	1	< 0.1%
894.75	1	< 0.1%

PM10
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	29575
Distinct (%)	45.3%
Missing	42706
Missing (%)	39.5%
Infinite	0
Infinite (%)	0.0%
Mean	157.9684272

Minimum	0.01
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0.01
5-th percentile	30.27
Q1	70.15
median	122.09
Q3	208.67
95-th percentile	409.386
Maximum	1000
Range	999.99
Interquartile range (IQR)	138.52

Descriptive statistics

Standard deviation	123.4186718
Coefficient of variation (CV)	0.7812869569
Kurtosis	3.383081112
Mean	157.9684272
Median Absolute Deviation (MAD)	61.83
Skewness	1.644048099
Sum	10319919.38
Variance	15232.16854
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
94	12	< 0.1%
71.88	12	< 0.1%
71.05	12	< 0.1%
108.46	11	< 0.1%
55.66	11	< 0.1%
56.6	11	< 0.1%
41.62	10	< 0.1%
31	10	< 0.1%
46.68	10	< 0.1%
65.88	10	< 0.1%
Other values (29565)	65220	60.4%
(Missing)	42706	39.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	1	< 0.1%
0.02	1	< 0.1%
0.03	1	< 0.1%
0.04	2	< 0.1%
0.06	1	< 0.1%
0.07	1	< 0.1%
0.08	1	< 0.1%
0.09	2	< 0.1%
0.1	3	< 0.1%
0.12	3	< 0.1%

Value	Count	Frequency (%)
1000	1	< 0.1%
985	2	< 0.1%
976.77	1	< 0.1%
960.98	1	< 0.1%
955.6	1	< 0.1%
952	1	< 0.1%
942	1	< 0.1%
938.5	1	< 0.1%
936.25	1	< 0.1%
933.05	1	< 0.1%

NO
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	11963
Distinct (%)	13.2%
Missing	17106
Missing (%)	15.8%
Infinite	0
Infinite (%)	0.0%
Mean	23.12342399

Minimum	0.01
Maximum	470
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0.01
5-th percentile	1.5
Q1	4.84
median	10.29
Q3	24.98
95-th percentile	93.766
Maximum	470
Range	469.99
Interquartile range (IQR)	20.14

Descriptive statistics

Standard deviation	34.49101855
Coefficient of variation (CV)	1.49160516
Kurtosis	14.05293685
Mean	23.12342399
Median Absolute Deviation (MAD)	7.02
Skewness	3.288711003
Sum	2102589.82
Variance	1189.63036
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.5	81	0.1%
2.89	79	0.1%
2.93	79	0.1%
0.73	77	0.1%
2.49	77	0.1%
3	76	0.1%
2.87	76	0.1%
2.84	75	0.1%
2.95	75	0.1%
3.99	75	0.1%
Other values (11953)	90159	83.5%
(Missing)	17106	15.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	1	< 0.1%
0.02	10	< 0.1%
0.03	4	< 0.1%
0.04	2	< 0.1%
0.06	3	< 0.1%
0.07	1	< 0.1%
0.08	3	< 0.1%
0.09	2	< 0.1%
0.1	4	< 0.1%
0.11	4	< 0.1%

Value	Count	Frequency (%)
470	1	< 0.1%
437.85	1	< 0.1%
436.8	1	< 0.1%
429.77	1	< 0.1%
403.94	1	< 0.1%
390.68	1	< 0.1%
383.14	1	< 0.1%
382.44	1	< 0.1%
374.71	1	< 0.1%
373.9	1	< 0.1%

NO2
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	12050
Distinct (%)	13.2%
Missing	16547
Missing (%)	15.3%
Infinite	0
Infinite (%)	0.0%
Mean	35.2407601

Minimum	0.01
Maximum	448.05
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0.01
5-th percentile	5.3935
Q1	15.09
median	27.21
Q3	46.93
95-th percentile	89.88
Maximum	448.05
Range	448.04
Interquartile range (IQR)	31.84

Descriptive statistics

Standard deviation	29.51082713
Coefficient of variation (CV)	0.8374060901
Kurtosis	11.06061697
Mean	35.2407601
Median Absolute Deviation (MAD)	14.41
Skewness	2.359287053
Sum	3224106.66
Variance	870.8889177
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	43	< 0.1%
17.58	39	< 0.1%
20	37	< 0.1%
16.07	37	< 0.1%
17.82	36	< 0.1%
9.47	36	< 0.1%
0.2	36	< 0.1%
9.14	36	< 0.1%
9.22	35	< 0.1%
13.6	35	< 0.1%
Other values (12040)	91118	84.3%
(Missing)	16547	15.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	4	< 0.1%
0.02	7	< 0.1%
0.03	9	< 0.1%
0.04	3	< 0.1%
0.05	3	< 0.1%
0.06	3	< 0.1%
0.07	7	< 0.1%
0.08	6	< 0.1%
0.09	7	< 0.1%
0.1	8	< 0.1%

Value	Count	Frequency (%)
448.05	1	< 0.1%
397.77	1	< 0.1%
397.31	1	< 0.1%
394.04	1	< 0.1%
393.08	1	< 0.1%
369.03	1	< 0.1%
363.75	1	< 0.1%
362.73	1	< 0.1%
362.5	1	< 0.1%
362.21	1	< 0.1%

NOx
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	15608
Distinct (%)	16.9%
Missing	15500
Missing (%)	14.3%
Infinite	0
Infinite (%)	0.0%
Mean	41.19505538

Minimum	0
Maximum	467.63
Zeros	4776
Zeros (%)	4.4%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	13.97
median	26.66
Q3	50.5
95-th percentile	134.153
Maximum	467.63
Range	467.63
Interquartile range (IQR)	36.53

Descriptive statistics

Standard deviation	45.1459756
Coefficient of variation (CV)	1.095907632
Kurtosis	8.454914527
Mean	41.19505538
Median Absolute Deviation (MAD)	15.84
Skewness	2.53978547
Sum	3811984.45
Variance	2038.159113
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4776	4.4%
6.24	601	0.6%
2.21	516	0.5%
9.05	37	< 0.1%
15.75	34	< 0.1%
16.56	34	< 0.1%
11.02	34	< 0.1%
22.02	34	< 0.1%
17.01	34	< 0.1%
15.09	33	< 0.1%
Other values (15598)	86402	80.0%
(Missing)	15500	14.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4776	4.4%
0.01	7	< 0.1%
0.02	3	< 0.1%
0.03	14	< 0.1%
0.04	13	< 0.1%
0.05	4	< 0.1%
0.06	2	< 0.1%
0.07	3	< 0.1%
0.08	2	< 0.1%
0.09	2	< 0.1%

Value	Count	Frequency (%)
467.63	1	< 0.1%
453.61	1	< 0.1%
442.69	1	< 0.1%
440.31	1	< 0.1%
434.9	1	< 0.1%
429.38	1	< 0.1%
402.27	1	< 0.1%
399.87	1	< 0.1%
395.86	1	< 0.1%
395.33	1	< 0.1%

NH3
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	9119
Distinct (%)	15.2%
Missing	48105
Missing (%)	44.5%
Infinite	0
Infinite (%)	0.0%
Mean	28.73287519

Minimum	0.01
Maximum	418.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0.01
5-th percentile	3.85
Q1	11.9
median	23.59
Q3	38.1375
95-th percentile	70.23
Maximum	418.9
Range	418.89
Interquartile range (IQR)	26.2375

Descriptive statistics

Standard deviation	24.89779732
Coefficient of variation (CV)	0.8665264843
Kurtosis	22.77179802
Mean	28.73287519
Median Absolute Deviation (MAD)	12.6
Skewness	3.218919233
Sum	1721961.21
Variance	619.9003114
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.42	49	< 0.1%
6.29	42	< 0.1%
14.62	39	< 0.1%
6.3	38	< 0.1%
6.28	38	< 0.1%
6.31	36	< 0.1%
6.6	34	< 0.1%
10.42	33	< 0.1%
6.25	32	< 0.1%
6.32	32	< 0.1%
Other values (9109)	59557	55.1%
(Missing)	48105	44.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	4	< 0.1%
0.02	9	< 0.1%
0.03	1	< 0.1%
0.04	2	< 0.1%
0.05	2	< 0.1%
0.06	6	< 0.1%
0.07	1	< 0.1%
0.08	2	< 0.1%
0.09	1	< 0.1%
0.1	23	< 0.1%

Value	Count	Frequency (%)
418.9	1	< 0.1%
408.58	1	< 0.1%
379.32	1	< 0.1%
371.36	1	< 0.1%
365.68	1	< 0.1%
361.75	1	< 0.1%
356.73	1	< 0.1%
352.89	1	< 0.1%
349.25	1	< 0.1%
335.91	1	< 0.1%

CO
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	2352
Distinct (%)	2.5%
Missing	12998
Missing (%)	12.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.60574934

Minimum	0
Maximum	175.81
Zeros	7280
Zeros (%)	6.7%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.53
median	0.91
Q3	1.45
95-th percentile	3.38
Maximum	175.81
Range	175.81
Interquartile range (IQR)	0.92

Descriptive statistics

Standard deviation	4.369577753
Coefficient of variation (CV)	2.721207878
Kurtosis	224.1688928
Mean	1.60574934
Median Absolute Deviation (MAD)	0.43
Skewness	12.19795088
Sum	152605.6
Variance	19.09320974
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7280	6.7%
0.64	713	0.7%
0.66	696	0.6%
0.7	688	0.6%
0.78	679	0.6%
0.74	673	0.6%
0.68	671	0.6%
0.6	662	0.6%
0.79	659	0.6%
0.76	656	0.6%
Other values (2342)	81660	75.6%
(Missing)	12998	12.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7280	6.7%
0.01	96	0.1%
0.02	125	0.1%
0.03	54	< 0.1%
0.04	52	< 0.1%
0.05	73	0.1%
0.06	54	< 0.1%
0.07	45	< 0.1%
0.08	54	< 0.1%
0.09	59	0.1%

Value	Count	Frequency (%)
175.81	1	< 0.1%
145.32	1	< 0.1%
134.85	1	< 0.1%
132.47	1	< 0.1%
132.07	1	< 0.1%
124.01	1	< 0.1%
119.68	1	< 0.1%
119.3	1	< 0.1%
118.02	1	< 0.1%
118	1	< 0.1%

SO2
Real number (ℝ_≥0)

MISSING

Distinct	5801
Distinct (%)	7.0%
Missing	25204
Missing (%)	23.3%
Infinite	0
Infinite (%)	0.0%
Mean	12.2576341

Minimum	0.01
Maximum	195.65
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0.01
5-th percentile	2.07
Q1	5.04
median	8.95
Q3	14.92
95-th percentile	32.54
Maximum	195.65
Range	195.64
Interquartile range (IQR)	9.88

Descriptive statistics

Standard deviation	12.98472338
Coefficient of variation (CV)	1.059317261
Kurtosis	34.72063189
Mean	12.2576341
Median Absolute Deviation (MAD)	4.54
Skewness	4.581281421
Sum	1015312.09
Variance	168.6030412
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.4	84	0.1%
3.38	80	0.1%
4	79	0.1%
5.86	78	0.1%
3.28	75	0.1%
3.51	75	0.1%
3.48	75	0.1%
6.42	74	0.1%
5.8	74	0.1%
6.99	74	0.1%
Other values (5791)	82063	76.0%
(Missing)	25204	23.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	2	< 0.1%
0.02	1	< 0.1%
0.03	3	< 0.1%
0.04	6	< 0.1%
0.05	3	< 0.1%
0.06	8	< 0.1%
0.07	3	< 0.1%
0.08	10	< 0.1%
0.09	4	< 0.1%
0.1	6	< 0.1%

Value	Count	Frequency (%)
195.65	1	< 0.1%
193.86	1	< 0.1%
187.02	1	< 0.1%
186.08	1	< 0.1%
182.39	1	< 0.1%
180.85	1	< 0.1%
179.18	1	< 0.1%
178.93	1	< 0.1%
178.63	1	< 0.1%
178.58	1	< 0.1%

O3
Real number (ℝ_≥0)

MISSING

Distinct	11166
Distinct (%)	13.5%
Missing	25568
Missing (%)	23.7%
Infinite	0
Infinite (%)	0.0%
Mean	38.13483551

Minimum	0.01
Maximum	963
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0.01
5-th percentile	7.02
Q1	18.895
median	30.84
Q3	47.14
95-th percentile	81
Maximum	963
Range	962.99
Interquartile range (IQR)	28.245

Descriptive statistics

Standard deviation	39.12800382
Coefficient of variation (CV)	1.026043598
Kurtosis	75.83136294
Mean	38.13483551
Median Absolute Deviation (MAD)	13.49
Skewness	6.844483445
Sum	3144865.48
Variance	1531.000683
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16.48	35	< 0.1%
22.94	34	< 0.1%
23.6	33	< 0.1%
22.5	33	< 0.1%
34.4	32	< 0.1%
25.64	31	< 0.1%
19.12	31	< 0.1%
23.59	31	< 0.1%
21.4	30	< 0.1%
21.28	29	< 0.1%
Other values (11156)	82148	76.0%
(Missing)	25568	23.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	4	< 0.1%
0.02	9	< 0.1%
0.03	4	< 0.1%
0.04	3	< 0.1%
0.05	4	< 0.1%
0.06	3	< 0.1%
0.07	3	< 0.1%
0.08	2	< 0.1%
0.09	3	< 0.1%
0.1	11	< 0.1%

Value	Count	Frequency (%)
963	1	< 0.1%
868.2	1	< 0.1%
819.06	1	< 0.1%
777.67	1	< 0.1%
763.12	1	< 0.1%
757	1	< 0.1%
714.75	1	< 0.1%
705.32	1	< 0.1%
698.67	1	< 0.1%
694.96	1	< 0.1%

Benzene
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	3017
Distinct (%)	3.9%
Missing	31455
Missing (%)	29.1%
Infinite	0
Infinite (%)	0.0%
Mean	3.35802925

Minimum	0
Maximum	455.03
Zeros	12602
Zeros (%)	11.7%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.16
median	1.21
Q3	3.61
95-th percentile	11.35
Maximum	455.03
Range	455.03
Interquartile range (IQR)	3.45

Descriptive statistics

Standard deviation	11.15623448
Coefficient of variation (CV)	3.322256492
Kurtosis	695.2028255
Mean	3.35802925
Median Absolute Deviation (MAD)	1.21
Skewness	21.61702016
Sum	257157.88
Variance	124.4615677
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	12602	11.7%
0.1	689	0.6%
0.01	541	0.5%
0.02	474	0.4%
0.12	439	0.4%
0.11	422	0.4%
0.03	420	0.4%
0.05	409	0.4%
0.04	403	0.4%
0.13	398	0.4%
Other values (3007)	59783	55.3%
(Missing)	31455	29.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	12602	11.7%
0.01	541	0.5%
0.02	474	0.4%
0.03	420	0.4%
0.04	403	0.4%
0.05	409	0.4%
0.06	374	0.3%
0.07	321	0.3%
0.08	337	0.3%
0.09	337	0.3%

Value	Count	Frequency (%)
455.03	1	< 0.1%
454.85	1	< 0.1%
449.38	1	< 0.1%
448.59	1	< 0.1%
445.83	1	< 0.1%
443.63	1	< 0.1%
438.01	1	< 0.1%
435.9	1	< 0.1%
435.09	1	< 0.1%
432.94	1	< 0.1%

Toluene
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	8713
Distinct (%)	12.6%
Missing	38702
Missing (%)	35.8%
Infinite	0
Infinite (%)	0.0%
Mean	15.34539426

Minimum	0
Maximum	454.85
Zeros	10455
Zeros (%)	9.7%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.69
median	4.33
Q3	17.51
95-th percentile	64.934
Maximum	454.85
Range	454.85
Interquartile range (IQR)	16.82

Descriptive statistics

Standard deviation	29.3485873
Coefficient of variation (CV)	1.912533938
Kurtosis	33.33721267
Mean	15.34539426
Median Absolute Deviation (MAD)	4.33
Skewness	4.598334818
Sum	1063942.22
Variance	861.3395766
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10455	9.7%
0.01	268	0.2%
0.02	199	0.2%
0.07	198	0.2%
0.03	179	0.2%
0.04	173	0.2%
0.1	173	0.2%
0.08	167	0.2%
0.06	161	0.1%
0.09	153	0.1%
Other values (8703)	57207	53.0%
(Missing)	38702	35.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10455	9.7%
0.01	268	0.2%
0.02	199	0.2%
0.03	179	0.2%
0.04	173	0.2%
0.05	147	0.1%
0.06	161	0.1%
0.07	198	0.2%
0.08	167	0.2%
0.09	153	0.1%

Value	Count	Frequency (%)
454.85	1	< 0.1%
454.12	1	< 0.1%
449.14	1	< 0.1%
448.87	1	< 0.1%
445.84	1	< 0.1%
443.63	1	< 0.1%
437.77	1	< 0.1%
435.94	1	< 0.1%
434.92	1	< 0.1%
433.02	1	< 0.1%

Xylene
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	1892
Distinct (%)	8.3%
Missing	85137
Missing (%)	78.8%
Infinite	0
Infinite (%)	0.0%
Mean	2.423446153

Minimum	0
Maximum	170.37
Zeros	6083
Zeros (%)	5.6%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.4
Q3	2.11
95-th percentile	10.7315
Maximum	170.37
Range	170.37
Interquartile range (IQR)	2.11

Descriptive statistics

Standard deviation	6.472408501
Coefficient of variation (CV)	2.670745745
Kurtosis	119.5691605
Mean	2.423446153
Median Absolute Deviation (MAD)	0.4
Skewness	8.629738992
Sum	55492.07
Variance	41.8920718
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6083	5.6%
0.01	500	0.5%
0.02	423	0.4%
0.1	327	0.3%
0.03	297	0.3%
0.04	241	0.2%
0.05	188	0.2%
0.12	183	0.2%
0.06	180	0.2%
0.11	168	0.2%
Other values (1882)	14308	13.2%
(Missing)	85137	78.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6083	5.6%
0.01	500	0.5%
0.02	423	0.4%
0.03	297	0.3%
0.04	241	0.2%
0.05	188	0.2%
0.06	180	0.2%
0.07	151	0.1%
0.08	148	0.1%
0.09	135	0.1%

Value	Count	Frequency (%)
170.37	1	< 0.1%
137.45	1	< 0.1%
133.6	1	< 0.1%
132.97	1	< 0.1%
129.28	1	< 0.1%
125.18	1	< 0.1%
123.29	1	< 0.1%
116.62	1	< 0.1%
109.98	1	< 0.1%
109.23	1	< 0.1%

AQI
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	930
Distinct (%)	1.1%
Missing	21010
Missing (%)	19.4%
Infinite	0
Infinite (%)	0.0%
Mean	179.7492904

Minimum	8
Maximum	2049
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	8
5-th percentile	47
Q1	86
median	132
Q3	254
95-th percentile	415
Maximum	2049
Range	2041
Interquartile range (IQR)	168

Descriptive statistics

Standard deviation	131.3243389
Coefficient of variation (CV)	0.7305972588
Kurtosis	8.532544269
Mean	179.7492904
Median Absolute Deviation (MAD)	62
Skewness	1.930087687
Sum	15642682
Variance	17246.08198
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
104	615	0.6%
102	593	0.5%
106	587	0.5%
108	561	0.5%
100	560	0.5%
88	549	0.5%
98	547	0.5%
90	546	0.5%
92	546	0.5%
78	545	0.5%
Other values (920)	81376	75.3%
(Missing)	21010	19.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8	1	< 0.1%
10	2	< 0.1%
13	2	< 0.1%
14	7	< 0.1%
15	5	< 0.1%
16	10	< 0.1%
17	13	< 0.1%
18	11	< 0.1%
19	36	< 0.1%
20	49	< 0.1%

Value	Count	Frequency (%)
2049	1	< 0.1%
1917	1	< 0.1%
1842	1	< 0.1%
1747	1	< 0.1%
1719	1	< 0.1%
1672	1	< 0.1%
1646	1	< 0.1%
1630	1	< 0.1%
1613	1	< 0.1%
1595	1	< 0.1%

AQI_Bucket
Categorical

HIGH CORRELATION
MISSING

Distinct	6
Distinct (%)	< 0.1%
Missing	21010
Missing (%)	19.4%
Memory size	844.1 KiB

Moderate	29417
Satisfactory	23636
Very Poor	11762
Poor	11493
Good	5510

Length

Max length	12
Median length	8
Mean length	8.32036771
Min length	4

Characters and Unicode

Total characters	724080
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Moderate
2nd row	Moderate
3rd row	Moderate
4th row	Moderate
5th row	Moderate

Common Values

Value	Count	Frequency (%)
Moderate	29417	27.2%
Satisfactory	23636	21.9%
Very Poor	11762	10.9%
Poor	11493	10.6%
Good	5510	5.1%
Severe	5207	4.8%
(Missing)	21010	19.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
moderate	29417	29.8%
satisfactory	23636	23.9%
poor	23255	23.5%
very	11762	11.9%
good	5510	5.6%
severe	5207	5.3%

Most occurring characters

Value	Count	Frequency (%)
o	110583	15.3%
r	93277	12.9%
e	86217	11.9%
a	76689	10.6%
t	76689	10.6%
y	35398	4.9%
d	34927	4.8%
M	29417	4.1%
S	28843	4.0%
c	23636	3.3%
Other values (8)	128404	17.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	613531	84.7%
Uppercase Letter	98787	13.6%
Space Separator	11762	1.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	110583	18.0%
r	93277	15.2%
e	86217	14.1%
a	76689	12.5%
t	76689	12.5%
y	35398	5.8%
d	34927	5.7%
c	23636	3.9%
s	23636	3.9%
f	23636	3.9%
Other values (2)	28843	4.7%

Uppercase Letter

Value	Count	Frequency (%)
M	29417	29.8%
S	28843	29.2%
P	23255	23.5%
V	11762	11.9%
G	5510	5.6%

Space Separator

Value	Count	Frequency (%)
	11762	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	712318	98.4%
Common	11762	1.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	110583	15.5%
r	93277	13.1%
e	86217	12.1%
a	76689	10.8%
t	76689	10.8%
y	35398	5.0%
d	34927	4.9%
M	29417	4.1%
S	28843	4.0%
c	23636	3.3%
Other values (7)	116642	16.4%

Common

Value	Count	Frequency (%)
	11762	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	724080	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	110583	15.3%
r	93277	12.9%
e	86217	11.9%
a	76689	10.6%
t	76689	10.6%
y	35398	4.9%
d	34927	4.8%
M	29417	4.1%
S	28843	4.0%
c	23636	3.3%
Other values (8)	128404	17.7%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	StationId	Date	PM2.5	PM10	NO	NO2	NOx	NH3	CO	SO2	O3	Benzene	Toluene	Xylene	AQI	AQI_Bucket
0	AP001	2017-11-24	71.36	115.75	1.75	20.65	12.40	12.19	0.10	10.76	109.26	0.17	5.92	0.10	NaN	NaN
1	AP001	2017-11-25	81.40	124.50	1.44	20.50	12.08	10.72	0.12	15.24	127.09	0.20	6.50	0.06	184.0	Moderate
2	AP001	2017-11-26	78.32	129.06	1.26	26.00	14.85	10.28	0.14	26.96	117.44	0.22	7.95	0.08	197.0	Moderate
3	AP001	2017-11-27	88.76	135.32	6.60	30.85	21.77	12.91	0.11	33.59	111.81	0.29	7.63	0.12	198.0	Moderate
4	AP001	2017-11-28	64.18	104.09	2.56	28.07	17.01	11.42	0.09	19.00	138.18	0.17	5.02	0.07	188.0	Moderate
5	AP001	2017-11-29	72.47	114.84	5.23	23.20	16.59	12.25	0.16	10.55	109.74	0.21	4.71	0.08	173.0	Moderate
6	AP001	2017-11-30	69.80	114.86	4.69	20.17	14.54	10.95	0.12	14.07	118.09	0.16	3.52	0.06	165.0	Moderate
7	AP001	2017-12-01	73.96	113.56	4.58	19.29	13.97	10.95	0.10	13.90	123.80	0.17	2.85	0.04	191.0	Moderate
8	AP001	2017-12-02	89.90	140.20	7.71	26.19	19.87	13.12	0.10	19.37	128.73	0.25	2.79	0.07	191.0	Moderate
9	AP001	2017-12-03	87.14	130.52	0.97	21.31	12.12	14.36	0.15	11.41	114.80	0.23	3.82	0.04	227.0	Poor

Last rows

	StationId	Date	PM2.5	PM10	NO	NO2	NOx	NH3	CO	SO2	O3	Benzene	Toluene	Xylene	AQI	AQI_Bucket
108025	WB013	2020-06-22	15.10	30.98	2.59	18.04	20.63	30.34	0.67	1.50	25.84	1.28	8.32	NaN	38.0	Good
108026	WB013	2020-06-23	19.48	42.37	3.06	20.94	23.99	32.53	0.70	1.72	28.21	1.65	5.93	NaN	44.0	Good
108027	WB013	2020-06-24	20.05	46.63	3.78	15.28	19.06	18.89	0.66	7.08	41.56	1.14	7.24	NaN	59.0	Satisfactory
108028	WB013	2020-06-25	17.03	39.64	3.23	11.42	14.65	18.98	0.57	11.39	31.76	0.79	6.85	NaN	56.0	Satisfactory
108029	WB013	2020-06-26	9.79	19.87	23.51	16.50	40.02	25.09	0.66	10.34	30.19	0.93	6.37	NaN	50.0	Good
108030	WB013	2020-06-27	8.65	16.46	NaN	NaN	NaN	NaN	0.69	4.36	30.59	1.32	7.26	NaN	50.0	Good
108031	WB013	2020-06-28	11.80	18.47	NaN	NaN	NaN	NaN	0.68	3.49	38.95	1.42	7.92	NaN	65.0	Satisfactory
108032	WB013	2020-06-29	18.60	32.26	13.65	200.87	214.20	11.40	0.78	5.12	38.17	3.52	8.64	NaN	63.0	Satisfactory
108033	WB013	2020-06-30	16.07	39.30	7.56	29.13	36.69	29.26	0.69	5.88	29.64	1.86	8.40	NaN	57.0	Satisfactory
108034	WB013	2020-07-01	10.50	36.50	7.78	22.50	30.25	27.23	0.58	2.80	13.10	1.31	7.39	NaN	59.0	Satisfactory

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows